﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;

namespace TCL.FUNC
{
    public class NMTEx
    {
        public static String Execute()
        {
            try
            {
                MS_SQL.Create_Database();
                MS_SQL.Create_Table();
                MS_SQL.Create_User_Defined_Table_Types();
                MS_SQL.Create_Procedure();

                EntityObject.Create();

                DataAccessObject.Create();

                UI.Create_Ascx();
                UI.Create_Ascx_Cs();
                UI.Create_Ascx_Designer_Cs();

                UIEX.Create_Ascx();
                UIEX.Create_Ascx_Cs();
                UIEX.Create_Ascx_Designer_Cs();
                return String.Empty;
            }
            catch (Exception ex)
            {
                return ex.ToString();
            }
        }

        public class MS_SQL
        {
            public static void Create_Database()
            {
            }

            public static void Create_Table()
            {
            }

            public static void Create_User_Defined_Table_Types()
            {
            }

            public static void Create_Procedure()
            {
            }
        }

        public class EntityObject
        {
            public static void Create()
            {
            }
        }


        public class DataAccessObject
        {
            public static void Create()
            {
            }
        }


        public class UI
        {
            public static void Create_Ascx()
            {
            }

            public static void Create_Ascx_Cs()
            {
            }

            public static void Create_Ascx_Designer_Cs()
            {
            }
        }


        public class UIEX
        {
            public static void Create_Ascx()
            {
            }

            public static void Create_Ascx_Cs()
            {
            }

            public static void Create_Ascx_Designer_Cs()
            {
            }
        }

        public class DataSource
        {
            public static SortedList getAllSQLDataType()
            {
                SortedList slRet = new SortedList();
                slRet.Add("BIGINT", "BIGINT");
                slRet.Add("BINARY", "BINARY");
                slRet.Add("BIT", "BIT");
                slRet.Add("CHAR", "CHAR");
                slRet.Add("DATE", "DATE");
                slRet.Add("DATETIME", "DATETIME");
                slRet.Add("DATETIME2", "DATETIME2");
                slRet.Add("DATETIMEOFFSET", "DATETIMEOFFSET");
                slRet.Add("DECIMAL", "DECIMAL");
                slRet.Add("FLOAT", "FLOAT");
                slRet.Add("GEOGRAPHY", "GEOGRAPHY");
                slRet.Add("GEOMETRY", "GEOMETRY");
                slRet.Add("HIERARCHYID", "HIERARCHYID");
                slRet.Add("IMAGE", "IMAGE");
                slRet.Add("INT", "INT");
                slRet.Add("MONEY", "MONEY");
                slRet.Add("NCHAR", "NCHAR");
                slRet.Add("NTEXT", "NTEXT");
                slRet.Add("NUMERIC", "NUMERIC");
                slRet.Add("NVARCHAR", "NVARCHAR");
                slRet.Add("NVARCHAR(MAX)", "NVARCHAR(MAX)");
                slRet.Add("REAL", "REAL");
                slRet.Add("SMALLDATETIME", "SMALLDATETIME");
                slRet.Add("SMALLINT", "SMALLINT");
                slRet.Add("SMALLMONEY", "SMALLMONEY");
                slRet.Add("SQL_VARIANT", "SQL_VARIANT");
                slRet.Add("TEXT", "TEXT");
                slRet.Add("TIME", "TIME");
                slRet.Add("TIMESTAMP", "TIMESTAMP");
                slRet.Add("TINYINT", "TINYINT");
                slRet.Add("UNIQUEIDENTIFIER", "UNIQUEIDENTIFIER");
                slRet.Add("VARBINARY", "VARBINARY");
                slRet.Add("VARBINARY(MAX)", "VARBINARY(MAX)");
                slRet.Add("VARCHAR", "VARCHAR");
                slRet.Add("VARCHAR(MAX)", "VARCHAR(MAX)");
                slRet.Add("XML", "XML");
                return slRet;
            }

            public static SortedList getAllSQLForeignKey()
            {
                SortedList slRet = new SortedList();
                slRet.Add("", "");
                slRet.Add("tblSEO", "tblSEO");
                slRet.Add("tblOption", "tblOption");
                return slRet;
            }

            public static SortedList getAllCSDataType()
            {
                SortedList slRet = new SortedList();
                slRet.Add("Boolean", "Boolean");
                slRet.Add("Byte", "Byte");
                slRet.Add("Char", "Char");
                slRet.Add("DateTime", "DateTime");
                slRet.Add("DBNull", "DBNull");
                slRet.Add("Decimal", "Decimal");
                slRet.Add("Double", "Double");
                slRet.Add("Empty", "Empty");
                slRet.Add("Int16", "Int16");
                slRet.Add("Int32", "Int32");
                slRet.Add("Int64", "Int64");
                slRet.Add("Object", "Object");
                slRet.Add("SByte", "SByte");
                slRet.Add("Single", "Single");
                slRet.Add("String", "String");
                slRet.Add("UInt16", "UInt16");
                slRet.Add("UInt32", "UInt32");
                slRet.Add("UInt64", "UInt64");
                return slRet;
            }

            public static SortedList getAllCSCheckData()
            {
                SortedList slRet = new SortedList();
                slRet.Add("Email", "Email");
                slRet.Add("Telephone", "Telephone");
                slRet.Add("DateTime", "DateTime");
                slRet.Add("Date", "Date");
                slRet.Add("Number", "Number");
                return slRet;
            }

            public static SortedList getAllCSTypeInput()
            {
                SortedList slRet = new SortedList();
                slRet.Add("AdRotator", "AdRotator");
                slRet.Add("BulletedList", "BulletedList");
                slRet.Add("Button", "Button");
                slRet.Add("Calendar", "Calendar");
                slRet.Add("CheckBox", "CheckBox");
                slRet.Add("CheckBoxList", "CheckBoxList");
                slRet.Add("DropDownList", "DropDownList");
                slRet.Add("FileUpload", "FileUpload");
                slRet.Add("HiddenField", "HiddenField");
                slRet.Add("Hyperlink", "Hyperlink");

                slRet.Add("Image", "Image");
                slRet.Add("ImageButton", "ImageButton");
                slRet.Add("ImageMap", "ImageMap");
                slRet.Add("Label", "Label");
                slRet.Add("LinkButton", "LinkButton");
                slRet.Add("ListBox", "ListBox");
                slRet.Add("Literal", "Literal");
                slRet.Add("Localize", "Localize");



                slRet.Add("TextBox", "TextBox");
                slRet.Add("TextArea", "TextArea");
                slRet.Add("CKEditor", "CKEditor");
                return slRet;
            }

            public static SortedList getAllCSTypeForm()
            {
                SortedList slRet = new SortedList();
                slRet.Add("List-Detail", "List-Detail");
                slRet.Add("List-Edit", "List-Edit");
                return slRet;
            }
        }
    }
}
